CREATE TRIGGER [dbo].[AuditoriaUsuario] ON [dbo].[Usuario]
AFTER UPDATE
AS 
BEGIN
	SET NOCOUNT ON;

	declare @login varchar(10)
	select @login=login from inserted

	update Usuario set fechaActualizacion=GETDATE() where login=@login
	
END
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
CREATE TRIGGER [dbo].[AuditoriaInnovacion] ON [dbo].[Innovacion]
AFTER UPDATE
AS 
BEGIN
	SET NOCOUNT ON;

	declare @idInnovacion int
	select @idInnovacion=idInnovacion from inserted

	update Innovacion set fechaActualizacion=GETDATE() where idInnovacion=@idInnovacion
	
END
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
CREATE TRIGGER [dbo].[AuditoriaScore] ON [dbo].[Score]
AFTER UPDATE
AS 
BEGIN
	SET NOCOUNT ON;

	declare @login varchar(10),
			@idInnovacion int
	select @login=login, @idInnovacion=idInnovacion from inserted

	update Score set fechaActualizacion=GETDATE() where login=@login and idInnovacion=@idInnovacion
	
END